
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspSiteUserAccessRole_UPDATE
(
@roleId int = null,
@userId int = null,
@createDate datetime = null
)
AS

UPDATE
  [dbo].[SiteUser_AccessRole]
SET
  [RoleId] = @roleId,
  [UserId] = @userId,
  [CreateDate] = @createDate
WHERE
  [RoleId] = @roleId
AND
  [UserId] = @userId

GO
